interview

home / developersection / interviews / exist operator in sql server?

Exist Operator in Sql Server?

Manish Kumar 1167 15-Dec-2017

database sql server

Updated on 24-Sep-2020

Other

Message

15-Dec-2017

The EXISTS operator is used to test for the existence of any record in a subquery.

The EXISTS operator returns true if the subquery returns one or more records.

EXISTS Syntax

SELECT column_name(s)

FROM table_name

WHERE EXISTS

(SELECT column_name FROM table_name WHERE condition);